{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Cost Worksheet","Scoring Formula"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[16,1,16,2],[18,1,20,2],[21,1,21,2],[28,1,28,2]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment S - PBA Services Cost Worksheet"]
[]
[null,"Instructions for Supplier"]
[null,"\nSuppliers are bidding on the Design, Development and Implementation (DDI), monthly Operations and Maintenance (O&M) costs, and additional program support the Supplier will charge to administer the Pharmacy Benefit Administrator Services as described in the eRFP. Please refer to the instructions below, Attachment A eRFP document \"Section 5, Cost Proposal,\" Attachment C - Common Scope Requirements and Security Standards, and Attachment F - Pharmacy Benefit Administrator Services Scope of Work for details describing the scope to be provided before completing this Cost Worksheet."]
[null,1,"Suppliers shall complete the Cost Proposal worksheet using the cells highlighted in yellow."]
[null,2,"Suppliers shall not modify any cells in the spreadsheet other than those highlighted yellow. The other cells are fixed or will calculate automatically."]
[null,3,"Suppliers shall not modify the formulas in the worksheets."]
[null,4,"Suppliers shall insert 0 in any yellow highlighted cells that are not applicable or for which the proposed cost is zero ($0)."]
[null,5,"For evaluation purposes, the total cost will be determined by the value found in D14 which is comprised of the total DDI (Table A) and O&M (Tables B.1and B.2) costs over a period of ten (10) years."]
[]
[null,"Instructions for Adjusting Costs One or More Years After the Effective Date of the Master Agreement  "]
[]
[null,"For Participating Addenda signed one year or more years after the Effective Date of the Master Agreement, the cost will be adjusted using the Consumer Price Index Urban (CPI-U) to account for economic changes that may impact cost. "]
[]
[]
[null,"CPI-U for United States Adjustment Factor Calculation:"]
[null,"CPI-U Index for the month and year of the execution of a Participating Addendum"]
[null,"Less the CPI-U Index for the month and year of the Effective Date of the Master Agreement"]
[null,"Equals Index Point Change"]
[null,"Divided by CPI-U Index B: C/B = D"]
[null,"Result multiplied by 100: D*100 = E: Equals CPI-U Inflation Percentage"]
[null," "]
[null,"Steps to Adjust Costs for CPI-U"]
[null,1,"Follow the link below to access the CPI-U data."]
[null,null,"https://www.bls.gov/cpi/tables/supplemental-files/home.htm"]
[null,2,"Select, download and save the file with the most recently published CPI-U data that is available for the month the Participating Addendum is signed. (Also find and select the CPI-U for when the Master Agreement was originally executed). Use the “All Items” CPI-U “Unadjusted indexes” values instead of the “Seasonally adjusted indexes” values."]
[null,3,"Enter the CPI-U value from the previous step in field C92 \"CPI-U for Participating Addendum Date.\""]
[null,4,"Enter the CPI-U value for the month of the Effective Date of the Master Agreement in C91 \"CPI-U for Master Agreement Date MM/DD/20YY.\" "]
[null,5,"The “CPI-U Inflation Percentage” will be calculated automatically based on the values from steps 3 and 4. This will also automatically update all the CPI-U Adjusted Price fields in the cost tables."]
[null,6,"CPI-U Adjusted Prices will be subject to negotiation upon execution of a Participating Addendum."]

{"sheet":"Cost Worksheet","index":1,"n_rows":100,"n_cols":33,"rows_kept":100,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[13,3,13,6],[17,1,17,3],[25,1,25,2],[28,1,29,3],[28,4,29,4],[28,5,29,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,28,25],[28,26,29,26],[30,4,33,4],[30,5,33,5],[34,1,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,18,34,19],[34,20,34,21],[34,22,34,23],[34,24,34,25],[35,4,38,4],[35,5,38,5],[39,1,39,5],[39,6,39,7],[39,8,39,9],[39,10,39,11],[39,12,39,13],[39,14,39,15],[39,16,39,17],[39,18,39,19],[39,20,39,21],[39,22,39,23],[39,24,39,25],[40,4,43,4],[40,5,43,5],[44,1,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[44,18,44,19],[44,20,44,21],[44,22,44,23],[44,24,44,25],[45,4,48,4],[45,5,48,5],[49,1,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,13],[49,14,49,15],[49,16,49,17],[49,18,49,19],[49,20,49,21],[49,22,49,23],[49,24,49,25],[50,4,53,4],[50,5,53,5],[54,1,54,5],[54,6,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,13],[54,14,54,15],[54,16,54,17],[54,18,54,19],[54,20,54,21],[54,22,54,23],[54,24,54,25],[55,1,55,26],[58,1,59,3],[58,4,59,4],[58,5,59,5],[58,6,58,7],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,16,58,17],[58,18,58,19],[58,20,58,21],[58,22,58,23],[58,24,58,25],[58,26,59,26],[60,1,60,3],[60,4,63,4],[60,5,63,5],[60,26,63,26],[61,1,63,3],[64,1,64,5],[64,6,64,7],[64,8,64,9],[64,10,64,11],[64,12,64,13],[64,14,64,15],[64,16,64,17],[64,18,64,19],[64,20,64,21],[64,22,64,23],[64,24,64,25],[65,1,65,3],[65,4,68,4],[65,5,68,5],[65,26,68,26],[66,1,68,3],[69,1,69,5],[69,6,69,7],[69,8,69,9],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,16,69,17],[69,18,69,19],[69,20,69,21],[69,22,69,23],[69,24,69,25],[70,1,70,3],[70,4,73,4],[70,5,73,5],[70,26,73,26],[71,1,73,3],[74,1,74,5],[74,6,74,7],[74,8,74,9],[74,10,74,11],[74,12,74,13],[74,14,74,15],[74,16,74,17],[74,18,74,19],[74,20,74,21],[74,22,74,23],[74,24,74,25],[75,1,75,3],[75,4,78,4],[75,5,78,5],[75,26,78,26],[76,1,78,3],[79,1,79,5],[79,6,79,7],[79,8,79,9],[79,10,79,11],[79,12,79,13],[79,14,79,15],[79,16,79,17],[79,18,79,19],[79,20,79,21],[79,22,79,23],[79,24,79,25],[80,1,80,26],[83,1,83,5],[84,1,84,5],[84,6,84,7],[84,8,84,9],[84,10,84,11],[84,12,84,13],[84,14,84,15],[84,16,84,17],[84,18,84,19],[84,20,84,21],[84,22,84,23],[84,24,84,25],[84,26,85,26],[85,2,85,5],[86,2,86,5],[87,2,87,5],[88,2,88,5],[89,2,89,5],[90,1,90,25],[91,1,91,26]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment S - PBA Services Cost Worksheet"]
[null," "]
[null,"SUPPLIER LEGAL ENTITY NAME:","Magellan Medicaid Administration, LLC"]
[null,"SUPPLIER REPRESENTATIVE NAME:","Billy Thomas"]
[null,"SUPPLIER REPRESENTATIVE TITLE:","SVP, Account Management"]
[null,"DATE:","2024-04-30"]
[]
[null,"TOTAL EVALUATION COST AMOUNT (Sum of Evaluation Costs Below):",null,{"$f":"D26+AA35+AA40+AA45+AA50+AA55+AA65+AA70+AA75+AA80","v":{"v":299431316.3,"d":"$299,431,316.30"}}]
[]
[null,"Table A"]
[null,"Instructions: Please enter the costs to implement your services and/or Solution."]
[null,"Design, Development, and Implementation (DDI) Cost"]
[null,null,"Initial Cost","CPI-U Adjusted Cost"]
[null,"Project Planning and Startup",{"v":654979.2,"d":"$654,979.20"},{"$f":"+C20*$C$100","v":{"v":654979.2,"d":"$654,979.20"}}]
[null,"Design, Development, and Testing",{"v":1200795.19,"d":"$1,200,795.19"},{"v":1200795.19,"d":"$1,200,795.19"}]
[null,"Operational Readiness and Production Cutover",{"v":1091631.99,"d":"$1,091,631.99"},{"v":1091631.99,"d":"$1,091,631.99"}]
[null,"Training",{"v":764142.4,"d":"$764,142.40"},{"v":764142.4,"d":"$764,142.40"}]
[null,"Acceptance, Deployment",{"v":436652.8,"d":"$436,652.80"},{"v":436652.8,"d":"$436,652.80"}]
[null,"Certification",{"v":218326.4,"d":"$218,326.40"},{"v":218326.4,"d":"$218,326.40"}]
[null,"Total DDI Costs:",null,{"$f":"SUM(D20:D25)","v":{"v":4366527.9799999995,"d":"$4,366,527.98"}}]
[]
[null,"Table B.1"]
[null,"Point-of-Sale Claims Processing O&M Administrative Fees",null,null,"Evaluation Factor","Rate","Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Evaluation Total for Claims Processing Administration"]
[{"$nulls":6},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Tier 1 Administrative Fees",null,null,{"v":175000,"d":"175,000"},"Per Claim"]
[null,"Claims Processing Administrative Fees "]
[null,"Less than 200,000 Claims per Month",{"$nulls":4},{"v":1.6398,"d":"$1.64"},{"$f":"G33*$C$100","v":{"v":1.6398,"d":"$1.64"}},{"v":1.6508,"d":"$1.65"},{"$f":"I33*$C$100","v":{"v":1.6508,"d":"$1.65"}},{"v":1.6947,"d":"$1.69"},{"$f":"K33*$C$100","v":{"v":1.6947,"d":"$1.69"}},{"v":1.7399,"d":"$1.74"},{"$f":"M33*$C$100","v":{"v":1.7399,"d":"$1.74"}},{"v":1.7863,"d":"$1.79"},{"$f":"O33*$C$100","v":{"v":1.7863,"d":"$1.79"}},{"v":1.8399,"d":"$1.84"},{"$f":"Q33*$C$100","v":{"v":1.8399,"d":"$1.84"}},{"v":1.8892,"d":"$1.89"},{"$f":"S33*$C$100","v":{"v":1.8892,"d":"$1.89"}},{"v":1.94,"d":"$1.94"},{"$f":"U33*$C$100","v":{"v":1.94,"d":"$1.94"}},{"v":1.9922,"d":"$1.99"},{"$f":"W33*$C$100","v":{"v":1.9922,"d":"$1.99"}},{"v":2.0459,"d":"$2.05"},{"$f":"Y33*$C$100","v":{"v":2.0459,"d":"$2.05"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Tier 1 Evaluation Cost ",{"$nulls":4},{"$f":"MAX(ROUND(H33*E31*12,2),0)","v":{"v":3443580,"d":"=$3,443,580"}},null,{"$f":"MAX(ROUND(J33*E31*12,2),0)","v":{"v":3466680,"d":"=$3,466,680"}},null,{"$f":"MAX(ROUND(L33*E31*12,2),0)","v":{"v":3558870,"d":"=$3,558,870"}},null,{"$f":"MAX(ROUND(N33*E31*12,2),0)","v":{"v":3653790,"d":"=$3,653,790"}},null,{"$f":"MAX(ROUND(P33*E31*12,2),0)","v":{"v":3751230,"d":"=$3,751,230"}},null,{"$f":"MAX(ROUND(R33*E31*12,2),0)","v":{"v":3863790,"d":"=$3,863,790"}},null,{"$f":"MAX(ROUND(T33*E31*12,2),0)","v":{"v":3967320,"d":"=$3,967,320"}},null,{"$f":"MAX(ROUND(V33*E31*12,2),0)","v":{"v":4074000,"d":"=$4,074,000"}},null,{"$f":"MAX(ROUND(X33*E31*12,2),0)","v":{"v":4183620,"d":"=$4,183,620"}},null,{"$f":"MAX(ROUND(Z33*E31*12,2),0)","v":{"v":4296390,"d":"=$4,296,390"}},null,{"$f":"SUM(G35:Y35)","v":{"v":38259270,"d":"=$38,259,270"}}]
[null,"Tier 2 Administrative Fees",null,null,{"v":225000,"d":"225,000"},"Per Claim"]
[null,"Claims Processing Administrative Fees "]
[null,"Minimum of 200,000 Claims per Month",{"$nulls":4},{"v":1.3561,"d":"$1.36"},{"$f":"G38*$C$100","v":{"v":1.3561,"d":"$1.36"}},{"v":1.3689,"d":"$1.37"},{"$f":"I38*$C$100","v":{"v":1.3689,"d":"$1.37"}},{"v":1.4058,"d":"$1.41"},{"$f":"K38*$C$100","v":{"v":1.4058,"d":"$1.41"}},{"v":1.4439,"d":"$1.44"},{"$f":"M38*$C$100","v":{"v":1.4439,"d":"$1.44"}},{"v":1.483,"d":"$1.48"},{"$f":"O38*$C$100","v":{"v":1.483,"d":"$1.48"}},{"v":1.5275,"d":"$1.53"},{"$f":"Q38*$C$100","v":{"v":1.5275,"d":"$1.53"}},{"v":1.569,"d":"$1.57"},{"$f":"S38*$C$100","v":{"v":1.569,"d":"$1.57"}},{"v":1.6117,"d":"$1.61"},{"$f":"U38*$C$100","v":{"v":1.6117,"d":"$1.61"}},{"v":1.6557,"d":"$1.66"},{"$f":"W38*$C$100","v":{"v":1.6557,"d":"$1.66"}},{"v":1.701,"d":"$1.70"},{"$f":"Y38*$C$100","v":{"v":1.701,"d":"$1.70"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Tier 2 Evaluation Cost ",{"$nulls":4},{"$f":"MAX(ROUND(H38*E36*12,2),0)","v":{"v":3661470,"d":"=$3,661,470"}},null,{"$f":"MAX(ROUND(J38*E36*12,2),0)","v":{"v":3696030,"d":"=$3,696,030"}},null,{"$f":"MAX(ROUND(L38*E36*12,2),0)","v":{"v":3795660,"d":"=$3,795,660"}},null,{"$f":"MAX(ROUND(N38*E36*12,2),0)","v":{"v":3898530,"d":"=$3,898,530"}},null,{"$f":"MAX(ROUND(P38*E36*12,2),0)","v":{"v":4004100,"d":"=$4,004,100"}},null,{"$f":"MAX(ROUND(R38*E36*12,2),0)","v":{"v":4124250,"d":"=$4,124,250"}},null,{"$f":"MAX(ROUND(T38*E36*12,2),0)","v":{"v":4236300,"d":"=$4,236,300"}},null,{"$f":"MAX(ROUND(V38*E36*12,2),0)","v":{"v":4351590,"d":"=$4,351,590"}},null,{"$f":"MAX(ROUND(X38*E36*12,2),0)","v":{"v":4470390,"d":"=$4,470,390"}},null,{"$f":"MAX(ROUND(Z38*E36*12,2),0)","v":{"v":4592700,"d":"=$4,592,700"}},null,{"$f":"SUM(G40:Y40)","v":{"v":40831020,"d":"=$40,831,020"}}]
[null,"Tier 3 Administrative Fees",null,null,{"v":500000,"d":"500,000"},"Per Claim"]
[null,"Claims Processing Administrative Fees "]
[null,"Minimum of 500,000 Claims per Month",{"$nulls":4},{"v":0.81,"d":"$0.81"},{"$f":"G43*$C$100","v":{"v":0.81,"d":"$0.81"}},{"v":0.8262,"d":"$0.83"},{"$f":"I43*$C$100","v":{"v":0.8262,"d":"$0.83"}},{"v":0.8498,"d":"$0.85"},{"$f":"K43*$C$100","v":{"v":0.8498,"d":"$0.85"}},{"v":0.8741,"d":"$0.87"},{"$f":"M43*$C$100","v":{"v":0.8741,"d":"$0.87"}},{"v":0.8991,"d":"$0.90"},{"$f":"O43*$C$100","v":{"v":0.8991,"d":"$0.90"}},{"v":0.9261,"d":"$0.93"},{"$f":"Q43*$C$100","v":{"v":0.9261,"d":"$0.93"}},{"v":0.9526,"d":"$0.95"},{"$f":"S43*$C$100","v":{"v":0.9526,"d":"$0.95"}},{"v":0.9799,"d":"$0.98"},{"$f":"U43*$C$100","v":{"v":0.9799,"d":"$0.98"}},{"v":1.008,"d":"$1.01"},{"$f":"W43*$C$100","v":{"v":1.008,"d":"$1.01"}},{"v":1.037,"d":"$1.04"},{"$f":"Y43*$C$100","v":{"v":1.037,"d":"$1.04"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Tier 3 Evaluation Cost",{"$nulls":4},{"$f":"MAX(ROUND(H43*E41*12,2),0)","v":{"v":4860000,"d":"=$4,860,000"}},null,{"$f":"MAX(ROUND(J43*E41*12,2),0)","v":{"v":4957200,"d":"=$4,957,200"}},null,{"$f":"MAX(ROUND(L43*E41*12,2),0)","v":{"v":5098800,"d":"=$5,098,800"}},null,{"$f":"MAX(ROUND(N43*E41*12,2),0)","v":{"v":5244600,"d":"=$5,244,600"}},null,{"$f":"MAX(ROUND(P43*E41*12,2),0)","v":{"v":5394600,"d":"=$5,394,600"}},null,{"$f":"MAX(ROUND(R43*E41*12,2),0)","v":{"v":5556600,"d":"=$5,556,600"}},null,{"$f":"MAX(ROUND(T43*E41*12,2),0)","v":{"v":5715600,"d":"=$5,715,600"}},null,{"$f":"MAX(ROUND(V43*E41*12,2),0)","v":{"v":5879400,"d":"=$5,879,400"}},null,{"$f":"MAX(ROUND(X43*E41*12,2),0)","v":{"v":6048000,"d":"=$6,048,000"}},null,{"$f":"MAX(ROUND(Z43*E41*12,2),0)","v":{"v":6222000,"d":"=$6,222,000"}},null,{"$f":"SUM(G45:Y45)","v":{"v":54976800,"d":"=$54,976,800"}}]
[null,"Tier 4 Administrative Fees",null,null,{"v":750000,"d":"750,000"},"Per Claim"]
[null,"Claims Processing Administrative Fee"]
[null,"Minimum of 750,000 Claims per Month",{"$nulls":4},{"v":0.6611,"d":"$0.66"},{"$f":"G48*$C$100","v":{"v":0.6611,"d":"$0.66"}},{"v":0.6782,"d":"$0.68"},{"$f":"I48*$C$100","v":{"v":0.6782,"d":"$0.68"}},{"v":0.6981,"d":"$0.70"},{"$f":"K48*$C$100","v":{"v":0.6981,"d":"$0.70"}},{"v":0.7187,"d":"$0.72"},{"$f":"M48*$C$100","v":{"v":0.7187,"d":"$0.72"}},{"v":0.7398,"d":"$0.74"},{"$f":"O48*$C$100","v":{"v":0.7398,"d":"$0.74"}},{"v":0.762,"d":"$0.76"},{"$f":"Q48*$C$100","v":{"v":0.762,"d":"$0.76"}},{"v":0.7845,"d":"$0.78"},{"$f":"S48*$C$100","v":{"v":0.7845,"d":"$0.78"}},{"v":0.8076,"d":"$0.81"},{"$f":"U48*$C$100","v":{"v":0.8076,"d":"$0.81"}},{"v":0.8314,"d":"$0.83"},{"$f":"W48*$C$100","v":{"v":0.8314,"d":"$0.83"}},{"v":0.8559,"d":"$0.86"},{"$f":"Y48*$C$100","v":{"v":0.8559,"d":"$0.86"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Tier 4 Evaluation Cost",{"$nulls":4},{"$f":"MAX(ROUND(H48*E46*12,2),0)","v":{"v":5949900,"d":"=$5,949,900"}},null,{"$f":"MAX(ROUND(J48*E46*12,2),0)","v":{"v":6103800,"d":"=$6,103,800"}},null,{"$f":"MAX(ROUND(L48*E46*12,2),0)","v":{"v":6282900,"d":"=$6,282,900"}},null,{"$f":"MAX(ROUND(N48*E46*12,2),0)","v":{"v":6468300,"d":"=$6,468,300"}},null,{"$f":"MAX(ROUND(P48*E46*12,2),0)","v":{"v":6658200,"d":"=$6,658,200"}},null,{"$f":"MAX(ROUND(R48*E46*12,2),0)","v":{"v":6858000,"d":"=$6,858,000"}},null,{"$f":"MAX(ROUND(T48*E46*12,2),0)","v":{"v":7060500,"d":"=$7,060,500"}},null,{"$f":"MAX(ROUND(V48*E46*12,2),0)","v":{"v":7268400,"d":"=$7,268,400"}},null,{"$f":"MAX(ROUND(X48*E46*12,2),0)","v":{"v":7482600,"d":"=$7,482,600"}},null,{"$f":"MAX(ROUND(Z48*E46*12,2),0)","v":{"v":7703100,"d":"=$7,703,100"}},null,{"$f":"SUM(G50:Y50)","v":{"v":67835700,"d":"=$67,835,700"}}]
[null,"Tier 5 Administrative Fees",null,null,{"v":1000000,"d":"1,000,000"},"Per Claim"]
[null,"Claims Processing Administrative Fees "]
[null,"Minimum of 1,000,000 Claims per Month",{"$nulls":4},{"v":0.5866,"d":"$0.59"},{"$f":"G53*$C$100","v":{"v":0.5866,"d":"$0.59"}},{"v":0.6042,"d":"$0.60"},{"$f":"I53*$C$100","v":{"v":0.6042,"d":"$0.60"}},{"v":0.6223,"d":"$0.62"},{"$f":"K53*$C$100","v":{"v":0.6223,"d":"$0.62"}},{"v":0.641,"d":"$0.64"},{"$f":"M53*$C$100","v":{"v":0.641,"d":"$0.64"}},{"v":0.6602,"d":"$0.66"},{"$f":"O53*$C$100","v":{"v":0.6602,"d":"$0.66"}},{"v":0.68,"d":"$0.68"},{"$f":"Q53*$C$100","v":{"v":0.68,"d":"$0.68"}},{"v":0.7004,"d":"$0.70"},{"$f":"S53*$C$100","v":{"v":0.7004,"d":"$0.70"}},{"v":0.7214,"d":"$0.72"},{"$f":"U53*$C$100","v":{"v":0.7214,"d":"$0.72"}},{"v":0.7431,"d":"$0.74"},{"$f":"W53*$C$100","v":{"v":0.7431,"d":"$0.74"}},{"v":0.7654,"d":"$0.77"},{"$f":"Y53*$C$100","v":{"v":0.7654,"d":"$0.77"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Tier 5 Evaluation Cost",{"$nulls":4},{"$f":"MAX(ROUND(H53*E51*12,2),0)","v":{"v":7039200,"d":"=$7,039,200"}},null,{"$f":"MAX(ROUND(J53*E51*12,2),0)","v":{"v":7250400,"d":"=$7,250,400"}},null,{"$f":"MAX(ROUND(L53*E51*12,2),0)","v":{"v":7467600,"d":"=$7,467,600"}},null,{"$f":"MAX(ROUND(N53*E51*12,2),0)","v":{"v":7692000,"d":"=$7,692,000"}},null,{"$f":"MAX(ROUND(P53*E51*12,2),0)","v":{"v":7922400,"d":"=$7,922,400"}},null,{"$f":"MAX(ROUND(R53*E51*12,2),0)","v":{"v":8160000,"d":"=$8,160,000"}},null,{"$f":"MAX(ROUND(T53*E51*12,2),0)","v":{"v":8404800,"d":"=$8,404,800"}},null,{"$f":"MAX(ROUND(V53*E51*12,2),0)","v":{"v":8656800,"d":"=$8,656,800"}},null,{"$f":"MAX(ROUND(X53*E51*12,2),0)","v":{"v":8917200,"d":"=$8,917,200"}},null,{"$f":"MAX(ROUND(Z53*E51*12,2),0)","v":{"v":9184800,"d":"=$9,184,800"}},null,{"$f":"SUM(G55:Y55)","v":{"v":80695200,"d":"=$80,695,200"}}]
[]
[]
[null,"Table B.2"]
[null,"Additional Pharmacy Benefit Administrator Program (PBAP) O&M Admnistrative Fees",null,null,"Evaluation Factor","Rate","Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total \nEvaluation Cost"]
[{"$nulls":6},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Prior Authorizations (PA) Administrative Fee for the Preferred Drug List (PDL)",null,null,"N/A","Per Month",{"$nulls":20}," "]
[null,"The monthly administrative fee should include all O&M costs to provide prior authorizations for the PDL."]
[{"$nulls":6},{"v":58942.5,"d":"$58,942.50"},{"$f":"G63*C100","v":{"v":58942.5,"d":"$58,942.50"}},{"v":60710.78,"d":"$60,710.78"},{"$f":"I63*C100","v":{"v":60710.78,"d":"$60,710.78"}},{"v":62532.1,"d":"$62,532.10"},{"$f":"K63*C100","v":{"v":62532.1,"d":"$62,532.10"}},{"v":64408.06,"d":"$64,408.06"},{"$f":"M63*C100","v":{"v":64408.06,"d":"$64,408.06"}},{"v":66340.3,"d":"$66,340.30"},{"$f":"O63*C100","v":{"v":66340.3,"d":"$66,340.30"}},{"v":68330.51,"d":"$68,330.51"},{"$f":"Q63*C100","v":{"v":68330.51,"d":"$68,330.51"}},{"v":70380.43,"d":"$70,380.43"},{"$f":"S63*C100","v":{"v":70380.43,"d":"$70,380.43"}},{"v":72491.84,"d":"$72,491.84"},{"$f":"U63*C100","v":{"v":72491.84,"d":"$72,491.84"}},{"v":74666.6,"d":"$74,666.60"},{"$f":"W63*C100","v":{"v":74666.6,"d":"$74,666.60"}},{"v":76906.6,"d":"$76,906.60"},{"$f":"Y63*C100","v":{"v":76906.6,"d":"$76,906.60"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Total Period Cost",{"$nulls":4},{"$f":"MAX(ROUND(H63*12,2),0)","v":{"v":707310,"d":"=$707,310"}},null,{"$f":"MAX(ROUND(J63*12,2),0)","v":{"v":728529.36,"d":"=$728,529"}},null,{"$f":"MAX(ROUND(L63*12,2),0)","v":{"v":750385.2,"d":"=$750,385"}},null,{"$f":"MAX(ROUND(N63*12,2),0)","v":{"v":772896.72,"d":"=$772,897"}},null,{"$f":"MAX(ROUND(P63*12,2),0)","v":{"v":796083.6,"d":"=$796,084"}},null,{"$f":"MAX(ROUND(R63*12,2),0)","v":{"v":819966.12,"d":"=$819,966"}},null,{"$f":"MAX(ROUND(T63*12,2),0)","v":{"v":844565.16,"d":"=$844,565"}},null,{"$f":"MAX(ROUND(V63*12,2),0)","v":{"v":869902.08,"d":"=$869,902"}},null,{"$f":"MAX(ROUND(X63*12,2),0)","v":{"v":895999.2,"d":"=$895,999"}},null,{"$f":"MAX(ROUND(Z63*12,2),0)","v":{"v":922879.2,"d":"=$922,879"}},null,{"$f":"SUM(G65:Y65)","v":{"v":8108516.64,"d":"$8,108,516.64"}}]
[null,"Monthly PA Administrative Fee for the Provider Administered Drug List (PADL)",null,null,"N/A","Per Month",{"$nulls":20}," "]
[null,"The monthly administrative fee should include all O&M costs to provide prior authorizations for the PADL."]
[{"$nulls":6},{"v":26677.5,"d":"$26,677.50"},{"$f":"G68*C100","v":{"v":26677.5,"d":"$26,677.50"}},{"v":27477.83,"d":"$27,477.83"},{"$f":"I68*C100","v":{"v":27477.83,"d":"$27,477.83"}},{"v":28302.16,"d":"$28,302.16"},{"$f":"K68*C100","v":{"v":28302.16,"d":"$28,302.16"}},{"v":29151.22,"d":"$29,151.22"},{"$f":"M68*C100","v":{"v":29151.22,"d":"$29,151.22"}},{"v":30025.76,"d":"$30,025.76"},{"$f":"O68*C100","v":{"v":30025.76,"d":"$30,025.76"}},{"v":30926.53,"d":"$30,926.53"},{"$f":"Q68*C100","v":{"v":30926.53,"d":"$30,926.53"}},{"v":31854.33,"d":"$31,854.33"},{"$f":"S68*C100","v":{"v":31854.33,"d":"$31,854.33"}},{"v":32809.96,"d":"$32,809.96"},{"$f":"U68*C100","v":{"v":32809.96,"d":"$32,809.96"}},{"v":33794.26,"d":"$33,794.26"},{"$f":"W68*C100","v":{"v":33794.26,"d":"$33,794.26"}},{"v":34808.09,"d":"$34,808.09"},{"$f":"Y68*C100","v":{"v":34808.09,"d":"$34,808.09"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Total Period Cost",{"$nulls":4},{"$f":"MAX(ROUND(H68*12,2),0)","v":{"v":320130,"d":"=$320,130"}},null,{"$f":"MAX(ROUND(J68*12,2),0)","v":{"v":329733.96,"d":"=$329,734"}},null,{"$f":"MAX(ROUND(L68*12,2),0)","v":{"v":339625.92,"d":"=$339,626"}},null,{"$f":"MAX(ROUND(N68*12,2),0)","v":{"v":349814.64,"d":"=$349,815"}},null,{"$f":"MAX(ROUND(P68*12,2),0)","v":{"v":360309.12,"d":"=$360,309"}},null,{"$f":"MAX(ROUND(R68*12,2),0)","v":{"v":371118.36,"d":"=$371,118"}},null,{"$f":"MAX(ROUND(T68*12,2),0)","v":{"v":382251.96,"d":"=$382,252"}},null,{"$f":"MAX(ROUND(V68*12,2),0)","v":{"v":393719.52,"d":"=$393,720"}},null,{"$f":"MAX(ROUND(X68*12,2),0)","v":{"v":405531.12,"d":"=$405,531"}},null,{"$f":"MAX(ROUND(Z68*12,2),0)","v":{"v":417697.08,"d":"=$417,697"}},null,{"$f":"SUM(G70:Y70)","v":{"v":3669931.68,"d":"$3,669,931.68"}},{"$nulls":5}," "]
[null,"Appeals Administrative Fee",null,null,250,"Per Appeal",{"$nulls":20}," "]
[null,"The administrative fee should include all O&M costs to provide the required services per appeal."]
[{"$nulls":6},{"v":7.5,"d":"$7.50"},{"$f":"G73*C100","v":{"v":7.5,"d":"$7.50"}},{"v":7.73,"d":"$7.73"},{"$f":"I73*C100","v":{"v":7.73,"d":"$7.73"}},{"v":7.96,"d":"$7.96"},{"$f":"K73*C100","v":{"v":7.96,"d":"$7.96"}},{"v":8.2,"d":"$8.20"},{"$f":"M73*C100","v":{"v":8.2,"d":"$8.20"}},{"v":8.45,"d":"$8.45"},{"$f":"O73*C100","v":{"v":8.45,"d":"$8.45"}},{"v":8.7,"d":"$8.70"},{"$f":"Q73*C100","v":{"v":8.7,"d":"$8.70"}},{"v":8.96,"d":"$8.96"},{"$f":"S73*C100","v":{"v":8.96,"d":"$8.96"}},{"v":9.23,"d":"$9.23"},{"$f":"U73*C100","v":{"v":9.23,"d":"$9.23"}},{"v":9.51,"d":"$9.51"},{"$f":"W73*C100","v":{"v":9.51,"d":"$9.51"}},{"v":9.8,"d":"$9.80"},{"$f":"Y73*C100","v":{"v":9.8,"d":"$9.80"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Total Evaluation Cost ",{"$nulls":4},{"$f":"MAX(ROUND(H73*E71*12,2),0)","v":{"v":22500,"d":"=$22,500"}},null,{"$f":"MAX(ROUND(J73*E71*12,2),0)","v":{"v":23190,"d":"=$23,190"}},null,{"$f":"MAX(ROUND(L73*E71*12,2),0)","v":{"v":23880,"d":"=$23,880"}},null,{"$f":"MAX(ROUND(N73*E71*12,2),0)","v":{"v":24600,"d":"=$24,600"}},null,{"$f":"MAX(ROUND(P73*E71*12,2),0)","v":{"v":25350,"d":"=$25,350"}},null,{"$f":"MAX(ROUND(R73*E71*12,2),0)","v":{"v":26100,"d":"=$26,100"}},null,{"$f":"MAX(ROUND(T73*E71*12,2),0)","v":{"v":26880,"d":"=$26,880"}},null,{"$f":"MAX(ROUND(V73*E71*12,2),0)","v":{"v":27690,"d":"=$27,690"}},null,{"$f":"MAX(ROUND(X73*E71*12,2),0)","v":{"v":28530,"d":"=$28,530"}},null,{"$f":"MAX(ROUND(Z73*E71*12,2),0)","v":{"v":29400,"d":"=$29,400"}},null,{"$f":"SUM(G75:Y75)","v":{"v":258120,"d":"$258,120.00"}},{"$nulls":5}," "]
[null,"Clinical Peer-to-Peer Reviews",null,null,250,"Per Clinical Peer-to-Peer Review",{"$nulls":20}," "]
[null,"The administrative fee should include all O&M costs to provide the required services per clinical peer-to-peer review."]
[{"$nulls":6},{"v":12.5,"d":"$12.50"},{"$f":"G78*C100","v":{"v":12.5,"d":"$12.50"}},{"v":12.88,"d":"$12.88"},{"$f":"I78*C100","v":{"v":12.88,"d":"$12.88"}},{"v":13.27,"d":"$13.27"},{"$f":"K78*C100","v":{"v":13.27,"d":"$13.27"}},{"v":13.67,"d":"$13.67"},{"$f":"M78*C100","v":{"v":13.67,"d":"$13.67"}},{"v":14.08,"d":"$14.08"},{"$f":"O78*C100","v":{"v":14.08,"d":"$14.08"}},{"v":14.5,"d":"$14.50"},{"$f":"Q78*C100","v":{"v":14.5,"d":"$14.50"}},{"v":14.94,"d":"$14.94"},{"$f":"S78*C100","v":{"v":14.94,"d":"$14.94"}},{"v":15.39,"d":"$15.39"},{"$f":"U78*C100","v":{"v":15.39,"d":"$15.39"}},{"v":15.85,"d":"$15.85"},{"$f":"W78*C100","v":{"v":15.85,"d":"$15.85"}},{"v":16.33,"d":"$16.33"},{"$f":"Y78*C100","v":{"v":16.33,"d":"$16.33"}}]
[{"$nulls":6},"X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor","X 12","months * Evaluation Factor"]
[null,"Total Evaluation Cost",{"$nulls":4},{"$f":"MAX(ROUND(H78*E76*12,2),0)","v":{"v":37500,"d":"=$37,500"}},null,{"$f":"MAX(ROUND(J78*E76*12,2),0)","v":{"v":38640,"d":"=$38,640"}},null,{"$f":"MAX(ROUND(L78*E76*12,2),0)","v":{"v":39810,"d":"=$39,810"}},null,{"$f":"MAX(ROUND(N78*E76*12,2),0)","v":{"v":41010,"d":"=$41,010"}},null,{"$f":"MAX(ROUND(P78*E76*12,2),0)","v":{"v":42240,"d":"=$42,240"}},null,{"$f":"MAX(ROUND(R78*E76*12,2),0)","v":{"v":43500,"d":"=$43,500"}},null,{"$f":"MAX(ROUND(T78*E76*12,2),0)","v":{"v":44820,"d":"=$44,820"}},null,{"$f":"MAX(ROUND(V78*E76*12,2),0)","v":{"v":46170,"d":"=$46,170"}},null,{"$f":"MAX(ROUND(X78*E76*12,2),0)","v":{"v":47550,"d":"=$47,550"}},null,{"$f":"MAX(ROUND(Z78*E76*12,2),0)","v":{"v":48990,"d":"=$48,990"}},null,{"$f":"SUM(G80:Y80)","v":{"v":430230,"d":"$430,230.00"}},{"$nulls":5}," "]
[]
[]
[null,"Table C "]
[null,"Instructions: Complete the section below by entering the Hourly Rate in the yellow boxes for each identified Role. As may be requested by the State on a case by case basis and agreed upon by the Contractor, the Contractor will provide ad hoc services related to potential tasks as described below.\n\nNote: These charges will only be billed for project-related services not specified in the eRFP and requested by the State for such services in writing. The total cost for all State requested and approved projects shall not exceed the amount indicated by the State in its Participating Addendum. The proposed costs will not be evaluated as part of the total contract value."]
[null,"Ad Hoc Professional Services",{"$nulls":4},"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Average of Hourly Rates"]
[null,"Role","Potential Responsibilities",{"$nulls":3},"Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate"]
[null,"Business Analyst","Evaluates business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing Solutions.",{"$nulls":3},{"v":89,"d":"$89.00"},{"$f":"MAX(ROUND(G87*$C$100,2),0)","v":{"v":89,"d":"$89.00"}},{"v":91.67,"d":"$91.67"},{"$f":"MAX(ROUND(I87*$C$100,2),0)","v":{"v":91.67,"d":"$91.67"}},{"v":94.42,"d":"$94.42"},{"$f":"MAX(ROUND(K87*$C$100,2),0)","v":{"v":94.42,"d":"$94.42"}},{"v":97.25,"d":"$97.25"},{"$f":"MAX(ROUND(M87*$C$100,2),0)","v":{"v":97.25,"d":"$97.25"}},{"v":100.17,"d":"$100.17"},{"$f":"MAX(ROUND(O87*$C$100,2),0)","v":{"v":100.17,"d":"$100.17"}},{"v":103.18,"d":"$103.18"},{"$f":"MAX(ROUND(Q87*$C$100,2),0)","v":{"v":103.18,"d":"$103.18"}},{"v":106.28,"d":"$106.28"},{"$f":"MAX(ROUND(S87*$C$100,2),0)","v":{"v":106.28,"d":"$106.28"}},{"v":109.47,"d":"$109.47"},{"$f":"MAX(ROUND(U87*$C$100,2),0)","v":{"v":109.47,"d":"$109.47"}},{"v":112.75,"d":"$112.75"},{"$f":"MAX(ROUND(W87*$C$100,2),0)","v":{"v":112.75,"d":"$112.75"}},{"v":116.13,"d":"$116.13"},{"$f":"MAX(ROUND(Y87*$C$100,2),0)","v":{"v":116.13,"d":"$116.13"}},{"$f":"(H87+J87+L87+N87+P87+R87+T87+V87+X87+Z87)/10","v":{"v":102.03200000000001,"d":"$102.03"}}]
[null,"Senior Developer","Responsible for designing, testing, and implementing new and updated software programs.",{"$nulls":3},{"v":151.44,"d":"$151.44"},{"$f":"MAX(ROUND(G88*$C$100,2),0)","v":{"v":151.44,"d":"$151.44"}},{"v":155.98,"d":"$155.98"},{"$f":"MAX(ROUND(I88*$C$100,2),0)","v":{"v":155.98,"d":"$155.98"}},{"v":160.66,"d":"$160.66"},{"$f":"MAX(ROUND(K88*$C$100,2),0)","v":{"v":160.66,"d":"$160.66"}},{"v":165.48,"d":"$165.48"},{"$f":"MAX(ROUND(M88*$C$100,2),0)","v":{"v":165.48,"d":"$165.48"}},{"v":170.44,"d":"$170.44"},{"$f":"MAX(ROUND(O88*$C$100,2),0)","v":{"v":170.44,"d":"$170.44"}},{"v":175.55,"d":"$175.55"},{"$f":"MAX(ROUND(Q88*$C$100,2),0)","v":{"v":175.55,"d":"$175.55"}},{"v":180.82,"d":"$180.82"},{"$f":"MAX(ROUND(S88*$C$100,2),0)","v":{"v":180.82,"d":"$180.82"}},{"v":186.24,"d":"$186.24"},{"$f":"MAX(ROUND(U88*$C$100,2),0)","v":{"v":186.24,"d":"$186.24"}},{"v":191.83,"d":"$191.83"},{"$f":"MAX(ROUND(W88*$C$100,2),0)","v":{"v":191.83,"d":"$191.83"}},{"v":197.58,"d":"$197.58"},{"$f":"MAX(ROUND(Y88*$C$100,2),0)","v":{"v":197.58,"d":"$197.58"}},{"$f":"(H88+J88+L88+N88+P88+R88+T88+V88+X88+Z88)/10","v":{"v":173.60199999999998,"d":"$173.60"}}]
[null,"Developer","Responsible for developing, coding, installing, and maintaining software systems.",{"$nulls":3},{"v":121.15,"d":"$121.15"},{"$f":"MAX(ROUND(G89*$C$100,2),0)","v":{"v":121.15,"d":"$121.15"}},{"v":124.78,"d":"$124.78"},{"$f":"MAX(ROUND(I89*$C$100,2),0)","v":{"v":124.78,"d":"$124.78"}},{"v":128.52,"d":"$128.52"},{"$f":"MAX(ROUND(K89*$C$100,2),0)","v":{"v":128.52,"d":"$128.52"}},{"v":132.38,"d":"$132.38"},{"$f":"MAX(ROUND(M89*$C$100,2),0)","v":{"v":132.38,"d":"$132.38"}},{"v":136.35,"d":"$136.35"},{"$f":"MAX(ROUND(O89*$C$100,2),0)","v":{"v":136.35,"d":"$136.35"}},{"v":140.44,"d":"$140.44"},{"$f":"MAX(ROUND(Q89*$C$100,2),0)","v":{"v":140.44,"d":"$140.44"}},{"v":144.65,"d":"$144.65"},{"$f":"MAX(ROUND(S89*$C$100,2),0)","v":{"v":144.65,"d":"$144.65"}},{"v":148.99,"d":"$148.99"},{"$f":"MAX(ROUND(U89*$C$100,2),0)","v":{"v":148.99,"d":"$148.99"}},{"v":153.46,"d":"$153.46"},{"$f":"MAX(ROUND(W89*$C$100,2),0)","v":{"v":153.46,"d":"$153.46"}},{"v":158.06,"d":"$158.06"},{"$f":"MAX(ROUND(Y89*$C$100,2),0)","v":{"v":158.06,"d":"$158.06"}},{"$f":"(H89+J89+L89+N89+P89+R89+T89+V89+X89+Z89)/10","v":{"v":138.87800000000001,"d":"$138.88"}}]
[null,"Quality assurance/Test","Works with the development team to debug code, correct errors, and troubleshoot any issues with software code.",{"$nulls":3},{"v":97.9,"d":"$97.90"},{"$f":"MAX(ROUND(G90*$C$100,2),0)","v":{"v":97.9,"d":"$97.90"}},{"v":100.84,"d":"$100.84"},{"$f":"MAX(ROUND(I90*$C$100,2),0)","v":{"v":100.84,"d":"$100.84"}},{"v":103.87,"d":"$103.87"},{"$f":"MAX(ROUND(K90*$C$100,2),0)","v":{"v":103.87,"d":"$103.87"}},{"v":106.99,"d":"$106.99"},{"$f":"MAX(ROUND(M90*$C$100,2),0)","v":{"v":106.99,"d":"$106.99"}},{"v":110.2,"d":"$110.20"},{"$f":"MAX(ROUND(O90*$C$100,2),0)","v":{"v":110.2,"d":"$110.20"}},{"v":113.51,"d":"$113.51"},{"$f":"MAX(ROUND(Q90*$C$100,2),0)","v":{"v":113.51,"d":"$113.51"}},{"v":116.92,"d":"$116.92"},{"$f":"MAX(ROUND(S90*$C$100,2),0)","v":{"v":116.92,"d":"$116.92"}},{"v":120.43,"d":"$120.43"},{"$f":"MAX(ROUND(U90*$C$100,2),0)","v":{"v":120.43,"d":"$120.43"}},{"v":124.04,"d":"$124.04"},{"$f":"MAX(ROUND(W90*$C$100,2),0)","v":{"v":124.04,"d":"$124.04"}},{"v":127.76,"d":"$127.76"},{"$f":"MAX(ROUND(Y90*$C$100,2),0)","v":{"v":127.76,"d":"$127.76"}},{"$f":"(H90+J90+L90+N90+P90+R90+T90+V90+X90+Z90)/10","v":{"v":112.24600000000001,"d":"$112.25"}}]
[null,"Total Ad Hoc Professional Services Cost (Sum of 10-Year Average of Hourly Rates for all Identified Roles)",{"$nulls":24},{"$f":"SUM(AA87:AA90)","v":{"v":526.758,"d":"$526.76"}}]
[]
[]
[null,"Table D"]
[null,"Consumer Price Index Urban (CPI-U) Adjustment:"]
[null,"A. CPI-U for Master Agreement Date MM/DD/20YY:",{"v":0,"d":"0.000000"}]
[null,"B. CPI-U for Participating Addendum Date:",{"v":0,"d":"0.000000"}]
[null,"C. Index Point Change equals B minus A:",{"$f":"C97-C96","v":{"v":0,"d":"0.000000"}}]
[null,"D. Equals C divided by A:",{"$f":"IFERROR(C98/C96,0)","v":{"v":0,"d":"0.000000"}}]
[null,"E. CPI-U Inflation Percentage equals B plus 1.00:",{"$f":"C99+1","v":{"v":1,"d":"1.000000"}}]

{"sheet":"Scoring Formula","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[8,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,14,3]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment S - PBA Services Cost Worksheet"]
[]
[null,"Cost Scoring Formula"]
[]
[]
[null,"\nThe Supplier deemed to have the most competitive cost response overall, as determined by the Lead State, will receive the maximum score for the cost criteria. As a general rule, other Suppliers’ cost responses will receive a percentage of the maximum score based on the percentage differential between the most competitive cost proposal and the specific proposal in question. This cost scoring can be accomplished using the following formula:"]
[null,"\nL/R x P = Z\n\nL = Price of the Supplier's response with the lowest cost.\nR = Total cost of the Proposal being ranked.\nP = Total points available for cost scoring.\nZ = Assigned Points."]
[null,"EXAMPLE  - The Lead State receives responses from two Suppliers on an RFP.  The RFP assigned 700 possible points for technical scores and 300 possible points for cost scores. Supplier A's cost proposal is $50,000. Supplier B's cost proposal is $55,000. As Supplier A offered the lowest cost, Supplier A receives 300 points. The issuing officer can calculate the number of cost points to assign to Supplier B's cost score by using the formula noted above. As shown below, Supplier B's total cost score is 272.7 points.\n\nL/R x P = Z\n($50,000/$55,000) x 300 = Z\n.909 x 300 = Z\n272.7 = Z"]